MacFormat 2000 July

home *** CD-ROM | disk | FTP | other *** search

/ MacFormat 2000 July / macformat-092.iso / MacFormat 92 CD / Shareware Plus / Applications / InBizness Fund Raiser Mac RT / Chckbook.FP3 (.txt) < prev next >

Wrap

FileMaker Pro Database | 2000-05-11 | 259.0 KB | 1,364 lines

work makAll play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All HBAM2016AUG95 Pro 3.0 All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a goodCopyright 1984-1997 Claris Corporation and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. All play and no work makes John a good boy. FPTH@ alisA HBAM3016AUG95@ check deposit cardM computerJ computer equipJ creditM credit cardM equipJ personal phone Pro 3.0F! Pro 3.0 - 4.1M1 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 5/4/00 BALANCE CATAGORY CATAGORY DEPOSIT CHECK LINK CCL COUNT CDL COUNT 5/4/00 ACCOUNT BALANCE AGREE BALANCE BALANCECALC CATAGORY DEPOSIT CHECK LINK CATEGORY CCL COUNT CCL SUM 8 CDL COUNT CDL SUM CHECK LINK CHECKED OFF BALANCE CLASS CLEAN UP BALANCES CLEARED CHECK CLEARED CHECK COUNT CLEARED CHECK SUM CLEARED DEPOSIT CLEARED DEPOSIT COUNT CLEARED DEPOSIT SUM CLEARED LINK CURRENTLAYOUTGLOBAL DARKGRAYTAB DEPOSIT DEPOSIT LINK DESCRIPTION GLOBALTABPICTURE GODO GLOBAL LAST 45 DAYS LICENSE LIGHTGRAYTAB MONTHNAMEOFDATE MONTHOFDATE NOTES NUMBER OFFICE EXPENSE LINK : from your financial institution. Balance - Used with the clean up button to calculate the current balance at the time. LeSaux Media Services 916 North Vermilion Danville, IL 61832 Telephone (217) 442-3028 Email: products@lesaux.com Web: http://www.lesaux.com About Preferences Ledger E Reconcile A Form View About DEV: Register Preferences DEV: All Fields @JA Reconcile RPT Month/Year w list RPT Month/Year RPT Month/Year Class PRINT: About/Help PRINT: Preferences PRINT: Form View PRINT: Reconcile Previous Balance GlobalB A Unique IDB Unique ID 2B UnCleared LinkB Clean Up BalancesB Office Expense LinkB Universal LinkB Deposit LinkB Check LinkB Catagory Deposit Check LinkB Deposit Credit A CDL CountB A CCL CountB A CCL Count A CCL Count A CCL Count A CCL Count A CCL Count AboutB Marchz 3/7/99C DepositF 717.49H 917.49I DepositM 1999r Marchz 3/9/99B SouthWestern BellD 9.95G 917.49H 907.54I CheckJ PhoneM E102R 9.95q 1999r Marchz -9.95 xA 3/19/2000C Test VendorD 907.54H 882.54M F203R 2000r Marchz yA 3/19/2000B Test VendorD 882.54H 852.54M F204R 2000r Marchz zA 3/19/2000B 52.54G 852.54H F205R 52.54q 2000r Marchz -52.54 5/5/2000B LeSaux Media ServicesD F206R 2000r Check otal Records PaymentJ Deposit Balance Category Class Notesw Memorizey Auto enterz Deposit{ Clean Up| Reconcile ABAF>> UA << ABEC>> ABED>> ABEE>> ABEF>> ABEG>> ABEH>> ABEJ>>EJ>>H>> ABEH>> ABEJ>> ` New Entry a Find Mode List View c Main Menu e1Checkbook Version 99 1999 LeSaux Media Services ~~~~~~ }}}}}} |||||| {{{{{{ zzzzzz yyyyyy xxxxxx wwwwww vvvvvv uuuuuu tttttt ssssss rrrrrr qqqqqq pppppp oooooo nnnnnn mmmmmm llllll kkkkkk jjjjjj iiiiii hhhhhh gggggg ffffff eeeeee dddddd cccccc bbbbbb aaaaaa `````` ______ ^^^^^^ ]]]]]] \\\\\\ [[[[[[ ZZZZZZ YYYYYY XXXXXX WWWWWW VVVVVV UUUUUU TTTTTT SSSSSS RRRRRR QQQQQQ PPPPPP OOOOOO NNNNNN MMMMMM LLLLLL KKKKKK JJJJJJ IIIIII HHHHHH GGGGGG FFFFFF EEEEEE DDDDDD CCCCCC BBBBBB AAAAAA @@@@@@ ?????? >>>>>> ====== <<<<<< ;;;;;; :::::: 999999 888888 777777 666666 555555 444444 333333 222222 111111 000000 ////// ...... ------ ,,,,,, ++++++ ****** )))))) (((((( '''''' &&&&&& %%%%%% $$$$$$ ###### """""" !!!!!! DEV: RegisterB TAs a default, the clean up script is set to run when the Checkbook file is opened. You can also select to perform this script when the database is closed or only when the clean button is pressed. You can set up Checkbook to perform the cleanup script automatically by using the control panel to the right. You can only select one at a time. You can also perform the clean up script at any time. The button to the right also activates the clean up script. You will find this button in the main data entry screen for checkbook. We will be looking at other ways to perform this step. If you come across a clean and simple solution, please feel free to send us an email. We ll be happy to share the secret with everyone and give you credit to boot. Clean UpK Checkbook Preferences !))!! !)1)1{ AA << ABEC>> ABED>> ABEE>> ABEF>> ABEG>> ABEH>> ABEJ>> L New Entry M Find Mode List View O Main Menu Go / Do Form View Preferences Go / Do PreferencesB Date Number Description PaymentJ Deposit Balance Category Class Notes ABAF>> Checkbook Ledger View ABEF>> ABEG>> ABEH>> 1)91!!))!!) JB9BB9) !!))11 PaymentJ Deposit Balance Category Class Notesw Memorizey Auto enterz Deposit{ Clean Up} Main~ Expense ABAF>> DEV: All FieldsB Clean Up Balances One rather annoying function that Checkbook needs to perform is called Clean Up. When you enter in your checkbook transactions (Checks, Deposits & ATM Withdrawals), you will enter then in for various dates. FileMaker however can not automatically insert a new record in the correct chronological order after it is entered (like Quicken does). Because of this, the current balance for each record will not reflect the actual balance for that day without a clean up process. The Checkbook cleanupB script finds all records, sorts them by the date entered, copies the balance from one record and pastes it into a previous balance field. automatically insert a new record in the correct chronological order after it is entered (like Quicken does). Because of this, the current balance for each record will not reflect the actual balance for that day without a clean up process. The Checkbook cleanup script f TAs a default, the clean up script is set to run when the Checkbook file is opened. You can also select to perform this script when the database is closed or only when the clean button is pressed. You can set up Checkbook to perform the cleanup script automatically by using the control panel to the right. You can only select one at a time. You can also perform the clean up script at any time. The button to the right also activates the clean up script. You will find this button in the main data entry screen for checkbook. We will be looking at other ways to perform this step. If you come across a clean and simple solution, please feel free to send us an email. We ll be happy to share the secret with everyone and give you credit to boot. Clean Up ABEC>> DohJPick the option you want to do or go to. Then click the yellow Do button. ted. - - - - - - - - > ABED>> ABEE>> ABEF>> ABEG>> ABEH>> ABEJ>> W New Entry X Find Mode List View Z Main Menu Go / Do Form View Preferences Form View Preferences 1/3/97C DepositE 2070.08H 2312.08I DepositM 1997r Januaryz 1/3/97B CompUSAD 2312.08H 1512.08I CheckJ Computer EquipK Payment on Toshiba ComputerM 1997r Januaryz 1/26/97C DepositE 1512.08H 1657.08I DepositM 1997r Januaryz 1/26/97C Deposit - MC/VisaF 1657.08H 1746.08I DepositM 1997r Januaryz 1/28/97B MBNAD 16.24E 1746.08H 1729.84I CheckJ Credit CardM 16.24q 1997r Januaryz -16.24 1/28/97B American ExpressD 502.40E 1729.84H 1227.44I CheckJ Credit CardM 502.4q 1997r Januaryz -502.4 2/28/99B SouthWestern BellD 9.95G 1227.44H 1217.49I CheckJ PhoneM E102R 9.95q 1999r Februaryz -9.95 3/7/99B Dwayne WrightD 1217.49H 717.49I CheckJ PersonalM Helvetica Geneva Times eWorld Tight A New Entry New Deposit "Deposit" DepositB$ "Deposit" Deposit Go To Category Memorize Transaction Execute Memorized Transaction "Deposit" Deposit Go To Category Memorize Transaction Execute Memorized Transaction Initiate Memorized Transaction A!Paste Amount From Bank Deposit DB Toggle Check Button Clean Up OPS: Opening Script Go To Class NAV: About A NAV: Help = "On Startup" On Startup ?This area gives you an overall view of the subtractions to your account (Checks and other Debits) and the additions to your account (Deposits and other Credits). You can toggle the for each by clicking on it. You can go to a particular record by clicking the arrow to the right of that listed item in either listing. OPS: Closing Script = "On Close" On Close Paste Office Expense ID ) + 1 ) + 1 A* [sub] Toggle Check Button Related Deposit c"Report: By Year/Month With Listing Report: By Year/Month g$Report: By Year/Month Classification Print Found Set Print Current Record Set Current Layout p'Print Choice then return to last layout ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" :RPTH alis FPTHA:Make the Dream:Desktop Folder:The Company Check :Memorized MSPCA NAMEA Memorized RPTHA Memorized alisA Make the Dream Memorized Ky`FMP3FMP3 The Company Check :Make the Dream:Desktop Folder:The Company Check :Memorized 0RPTH alis FPTHA0Hard Disk:Desktop Folder:The Checkbook:Checkbook MSPCA NAMEA Checkbook RPTHA Checkbook alisA Hard Disk ?u Checkbook Ky`FMP3FMP3 The Checkbook 0Hard Disk:Desktop Folder:The Checkbook:Checkbook /RPTH MSPC FPTHA/Hard Disk:Desktop Folder:OfficeOps 2.0:Help.FP3 MSPCA NAMEA Help.FP3 RPTHA Help.FP3 alisA Hard Disk Help.FP3 FMP3FMP3 OfficeOps 2.0 /Hard Disk:Desktop Folder:OfficeOps 2.0:Help.FP3 1RPTH FPTHA1Hard Disk:Desktop Folder:OfficeOps 2.0:OFFICE.FP3 MSPCA NAMEA OFFICE.FP3 RPTHA OFFICE.FP3 alisA Hard Disk OFFICE.FP3 FMP3FMP3 OfficeOps 2.0 1Hard Disk:Desktop Folder:OfficeOps 2.0:OFFICE.FP3 Date Number Description Payment Deposit Previous Balance Balance Category Class Notes Previous Balance Global Unique ID Unique ID 2 UnCleared Link Clean Up Balances Office Expense Link Universal Link Deposit Link Check Link Catagory Deposit Check Link + CDL Count - CCL Count CDL Sum CCL Sum Account Balance Cleared Link Cleared Check Cleared Deposit Checked Off Balance Cleared Check Sum Cleared Deposit Sum Cleared Check Count Cleared Deposit Count Last 45 Days CurrentLayoutGlobal GlobalTabPicture LightGrayTab DarkGrayTab Tab1Name Tab2Name Tab3Name Tab4Name Tab5Name Tab6Name Tab7Name Check Find Uncleared Deposits Deposit Find Cleared Deposits wwwwww UUUUUU DDDDDD """""" VDEFA( CategoryC Cleanup BalancesD ClassE Go/Do FMRLA FMRLA FMRLA FMRLA FMRLA Memorized by Unique ID 2B OFFICE By Office Expense LinkC Chckbook by Universal LinkD t screen or if there is a scrollable area on the screen, it will go to a different layout to print out as much of the information as possible. Checkbooks Clean Up Function One rather annoying function that Checkbook needs to perform is called "Clean Up." This script finds all records, sorts them by date/check#, copies the balance from one record and pastes it into a previous balance field. For more information, check the Setup Preferences button on the main screen or access the Checkbook online help files. Data Entry Of A New Record After you create a new record, you enter information into each field and then hit the TAB key. CHECKBOOK OPERATIONS New - Creates a new checking transaction record. Memorize-Memorize an entry to use again and again via the Auto Enter button Auto Enter - Automatically enter in a memorized transaction Clean Up - Sort by date and cleans up the current balance field Main - Takes you back to the main screen Help - Takes you to the 9BRkk ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" _:43]]^ W:;;^ ^V34Y zW .{ ONx4];^ $NV^: ]s]AX Nyz^e _^__^_^ _4W:_ (LIST LISTA VDEFA( (LIST VDEFA( (LIST LISTA#On Startup On Close On Command Only VDEFA( (LIST VDEFA( (LIST 4Go To Reconcile Find UnCleared Records Find UnCleared Deposits Find UnCleared Checks Find Cleared Deposits Find Cleared Checks Find Last 45 Days Find Checks Last 45 Days Find Deposits Last 45 Days REPORT: Checks By Year/Month With List REPORT: Checks By Year/Month REPORT: Check By Class/Year/Month CategoryC Cleanup BalancesD ClassE Go/Do 0RPTH alis FPTHA0Hard Disk:Desktop Folder:The Checkbook:Memorized MSPCA NAMEA Memorized RPTHA Memorized alisA Hard Disk ?u Memorized Ky`FMP3FMP3 The Checkbook 0Hard Disk:Desktop Folder:The Checkbook:Memorized GRPTH FPTHAGHard Disk:LeSaux CD:LMS_WIN:FM3_SOL:The Checkbook:Chckbook:Memorize.FP3 MSPCA NAMEA Memorize.FP3 RPTHA Memorize.FP3 Hard Disk Memorize.FP3 Ky`FMP3FMP3 Chckbook GHard Disk:LeSaux CD:LMS_WIN:FM3_SOL:The Checkbook:Chckbook:Memorize.FP3 IRPTH MSPC FPTHAIHard Disk:Church Business Work Area:Church Business 1.2:CB_Files:MAIN.FP3 MSPCA NAMEA MAIN.FP3 RPTHA MAIN.FP3 Hard Disk MAIN.FP3 FMP3FMP3 CB_Files IHard Disk:Church Business Work Area:Church Business 1.2:CB_Files:MAIN.FP3 IRPTH MSPC FPTHAIHard Disk:Church Business Work Area:Church Business 1.2:CB_Files:Help.FP3 MSPCA NAMEA Help.FP3 RPTHA Help.FP3 Hard Disk Help.FP3 FMP3FMP3 CB_Files IHard Disk:Church Business Work Area:Church Business 1.2:CB_Files:Help.FP3 ?This area gives you an overall view of the subtractions to your account (Checks and other Debits) and the additions to your account (Deposits and other Credits). You can toggle the for each by clicking on it. You can go to a particular record by clicking the arrow to the right of that listed item in either listing. AFAAABAFABAF>> AFAAABAFABAC>> AFAAABAFABAB>> AFAAABAFABAD>> AFAAABAFABAE>> Datebits) and the additions to your account (Deposits and other Credits). You can toggle the for each by clicking on it. You can go to a particular record by clicking the arrow to the right of that listed item in either listing. AFAAABAFABAF>> AFAAABAFABAC>> AFAAABAFABAB>> AFAAABAFABAD>> AFAAABAFABAE>> PAYMENT PREVIOUS BALANCE PREVIOUS BALANCE GLOBAL RECORD STATUS TAB1NAME TAB2NAME TAB3NAME TAB4NAME TAB5NAME TAB6NAME TAB7NAME UNCLEARED CHECK UNCLEARED CHECK COUNT UNCLEARED CHECK SUM UNCLEARED DEPOSIT UNCLEARED DEPOSIT COUNT UNCLEARED DEPOSIT SUM UNCLEARED LINK UNIQUE ID UNIQUE ID 2 UNIVERSAL LINK YEAROFDATE NotesB Date B NumberB DescriptionB PaymentB DepositB Previous BalanceB BalanceB CategoryB ClassB NotesB NotesB A Form ViewB Description Amount AFAAABAEABAF>> AFAAABAEABAC>> AFAAABAEABAB>> AFAAABAEABAD>> AFAAABAEABAG>> Description Amount h Overall << ABBI>> Checks, Debits i#Overall << ABBH>> Deposits, Credits ABBJ>> ABBK>> Checks and Debits Written Deposits and Credits Written Checkbook Reconcile o9The checkbook balance on checked off items is $ << ABBP>> p Cleared << ABCC>> Checks, Debits q#Cleared << ABCC>> Deposits, Credits ABCB>> ABCA>> t"UnCleared << ABCN>> Checks, Debits u%UnCleared << ABCL>> Deposits, Credits ABCM>> ABCO>> Go / DoGo Go / Do RZJ1) scRZZc{ {{scB JZkks 3RPTH FPTHA3Hard Disk:Desktop Folder:OfficeOps 2.0:Memorize.FP3 MSPCA NAMEA Memorize.FP3 RPTHA Memorize.FP3 alisA Hard Disk Memorize.FP3 Ky`FMP3FMP3 OfficeOps 2.0 3Hard Disk:Desktop Folder:OfficeOps 2.0:Memorize.FP3 #RPTH MSPC FPTHA#Stuff (1):Fund Raiser BETA:Main.FP3 MSPCA NAMEA Main.FP3 RPTHA Main.FP3 A ReconcileB AFAAABAFABAF>> AFAAABAFABAC>> AFAAABAFABAB>> AFAAABAFABAD>> AFAAABAFABAE>> Description Amount AFAAABAEABAF>> AFAAABAEABAC>> AFAAABAEABAB>> AFAAABAEABAD>> AFAAABAEABAG>> Description Amount h Overall << ABBI>> Checks, Debits i#Overall << ABBH>> Deposits, Credits ABBJ>> ABBK>> Checks and Debits Written Deposits and Credits Written Checkbook Reconcile o9The checkbook balance on checked off items is $ << ABBP>> p Cleared << ABCC>> Checks, Debits q#Cleared << ABCC>> Deposits, Credits ABCB>> ABCA>> t"UnCleared << ABCN>> Checks, Debits u%UnCleared << ABCL>> Deposits, Credits ABCM>> ABCO>>$ PRINT: Form ViewB PAYMENT YearOfDateB MonthOfDateB MonthNameOfDateB BalanceCalcB LicenseB AgreeB HelpB CurrentLayoutGlobalB GlobalTabPictureutGlobalB GlobalTabPicture GlobalTabPicture GlobalTabPicture GlobalTabPictureG RPT Month/Year ClassB Date Number Description PaymentJ Deposit Category ABDB>> ABDD>> << ABDB>> X/Checkbook Report (By Year / Month with listing) ABDI>> Checks Sum of $<< ABDF>> - << ABDJ>> Deposits Sum of $<< ABDG>> - << ABDE>> Overall Records Balance of $<< ABDH>> RPT Month/YearB 2A << ABEC>> ABED>> ABEE>> ABEF>> ABEG>> ABEH>> ABEJ>> = New Entry > Find Mode List View @ Main Menu Go / Do Form View Preferences ABED>> ABEE>> ABEF>> ABEG>> ABEH>> ABEJ>> = New Entry > Find Mode List View @ Main Menu Go / Do Form View Preferencesw Preferences Preferences Preferenceseferences Preferencesferencesferences Go / Do Form View Preferences Form View Preferences 0 = "Find UnCleared Records" Find UnCleared Records 0 = "Find UnCleared Deposits" Find UnCleared Deposits 0 = "Find UnCleared Checks" Find UnCleared Checks 0 = "Find Cleared Deposits" Find Cleared Deposits 0 = "Find Cleared Checks" Find Cleared Checks 0 = "Find Last 45 Days" Find Last 45 Days 0 = "Find Checks Last 45 Days " Find Checks Last 45 Days 0 = "Find Deposits Last 45 Days" Find Deposits Last 45 Days 0 = "Go To Reconcile" Go To Reconcile 0 = "REPORT: Checks By Year/Month With List" &REPORT: Checks By Year/Month With List 0 = "REPORT: Checks By Year/Month" REPORT: Checks By Year/Month 0 = "REPORT: Check By Class/Year/Month" !REPORT: Check By Class/Year/Month %A"Report: By Year/Month With Listing Cancel This script will show you the report in print preview mode. When you are finished viewing it, click the "Continue" button on the left side. This will bring up a dialog box asking you if you want to print it or not. alisA VDEF@ Checko Find Deposits In Last 45 Days Deposito Find Uncleared All s{ss{ ABDB>> ABDD>> << ABDB>> X"Checkbook Report (By Year / Month) Overall Records Payment Records Deposit Records Count Dollar Amount Count Dollar Amount Count Dollar Amount Deposit Find Cleared Checks Check Find All In Last 45 Days Find Checks In Last 45 Days )1)!))!!) !))!1 s cZRJBB9B99 Date Number Description Date Number Description PaymentJ Deposit Memorizey Auto enterz Deposit{ Clean Up} Category Class Z Reconcile RPT Month/Year w list Auto enterz Deposit{ Clean Up} ABAF>> Date Number Description Cancel The information has been printed. PRINT: Reconcile Cancel The information has been printed. 907.54P On Startup SOFTWARE LICENSE AGREEMENT - PLEASE READ THIS LICENSE CAREFULLY BEFORE USING THE ENCLOSED FILEMAKER TEMPLATE. BY USING THIS PRODUCT, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE. IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THIS PRODUCT AND DELETE IT FROM YOUR SYSTEM. The enclosed template is licensed, not sold, to you by Dwayne Wright - LeSaux Media Services ( Author ) for use only under the terms of this License, and Author reserves any rights not expressl Go To Related Check Go To Related Deposit Find Uncleared Checks Check Find Uncleared Deposits Deposit Find Cleared Deposits NAV: Preferences NAV: Form View NAV: List View <A NAV: Main NAV: Reconcile NAV: Tab 5 CDL SumB CCL SumB Account BalanceB Cleared LinkB Cleared CheckB Cleared DepositB Checked Off BalanceB Cleared Check SumB Cleared Deposit SumB Cleared Check CountB Cleared Deposit CountCheck SumB Cleared Deposit SumB Cleared Check CountB !))!! !)!!)) )RRB9 JRZk{ OPS: Opening Script OPS: Closing Script OPS: Set All Tabs Dark Gray OPS: Go/Do Global NAV: About NAV: Preferences NAV: Form View NAV: Reconcile NAV: Tab 5 NAV: Tab 6 NAV: List View NAV: Help NAV: Main PRINT: Help PRINT: Prefs PRINT: Form View PRINT: Reconcile * New Entry Find Entry New Deposit Go To Category Toggle Check Button 4( [sub] Toggle Check Button Related Check 6* [sub] Toggle Check Button Related Deposit Clean Up Go To Class Memorize Transaction Initiate Memorized Transaction Execute Memorized Transaction D!Paste Amount From Bank Deposit DB Paste Office Expense ID Go To Related Check Go To Related Deposit Find Uncleared All Find Uncleared Checks Find Uncleared Deposits Find Cleared Checks Find Cleared Deposits Find All In Last 45 Days Find Checks In Last 45 Days Find Deposits In Last 45 Days onth With Listing kJ9BB ss{kk {kZRJB991 !))!!)) )!!))!)) 1kcB99 {ZJB9 JRZk{ {scRRZRRc cZckks{ kJ9BB ss{kk kZRJB9911 kZRJB9911 kcZcs Clean Up Balances One rather annoying function that Checkbook needs to perform is called Clean Up. When you enter in your checkbook transactions (Checks, Deposits & ATM Withdrawals), you will enter then in for various dates. FileMaker however can not automatically insert a new record in the correct chronological order after it is entered (like Quicken does). Because of this, the current balance for each record will not reflect the actual balance for that day without a clean up process. The Checkbook cleanupB script finds all records, sorts them by the date entered, copies the balance from one record and pastes it into a previous balance field. PRINT: ReconcileB sZJJBJ UnCleared DepositB UnCleared CheckB UnCleared Deposit CountB UnCleared Deposit SumB UnCleared Check CountB UnCleared Check SumB Last 45 DaysB GoDo GlobalB Stuff (1) Main.FP3 FMP3FMP3 Fund Raiser BETA #Stuff (1):Fund Raiser BETA:Main.FP3 Dwayne Wright s Computer Stuff (1) Dwayne Wright {kRB9 Js{Z99BB9 'A$Report: By Year/Month Classification Cancel This script will show you the report in print preview mode. When you are finished viewing it, click the "Continue" button on the left side. This will bring up a dialog box asking you if you want to print it or not. Find Entry Check Agree OPS: Go/Do Global 0 = "Find Cleared Checks" Find Cleared Checks 0 = "Find Last 45 Days" Find Last 45 Days 0 = "Find Checks Last 45 Days " Find Checks Last 45 Days your account (Checks and other Debits) and the additions to your account (Deposits and other Credits). You can toggle the for each by clicking on it. You can go to a particular record by clicking the arrow to the right of that listed item in either listing. The Reporting Screens are accessed from the scripts menu. When you access a report, Checkbook 99 will do all the operations to run the report, go to the correct screen and show you how the report will print out. These scripts will show you the report in print preview mode. When you are finished viewing it, click the "Continue" button on the left side. This will bring up a dialog box asking you if you want to print it or not. THE BUTTONS New Record button goes to the Form View screen and creates a new blank record at the bottom of the list. Find Record button goes to the Form View screen and puts the database in Find Mode. Entry Screen button goes to the Form View screen. The Print button either prints the curren 9B1!)RkkccZRJJB99BBRRZs ABDB>> ABDD>> << ABDB>> X"Checkbook Report (By Year / Month) Count Dollar Amount Classification scRZZRJ A( [sub] Toggle Check Button Related Check A* [sub] Toggle Check Button Related Deposit NAV: Tab 6 Cancel I don't work yet!B PRINT: Prefs Cancel The information has been printed. PRINT: Form View Set Current Layout 2A'Print Choice then return to last layout Print!! Return!!! !Do you want to print this report or simply return to the previous screen. B+ ) = 1 OPS: Set All Tabs Dark Gray online help area Quit - Closes the Checkbook solution CHECKBOOK FIELDS Date - Date of the transaction Number - Check number used for the transaction Description - Who the check was addressed to and other info Payment - The payment amount for check or withdrawal transactions Deposit - The deposit amount for deposit transactions Category - Used to categorize the transaction. Each new & different entry will be added to an available list. This list can be accessed by clicking t he down arrow button to the right of the field. Class - Another way to sub-categorize a transaction. Each new & different entry will be added to an available list. This list can be accessed by clicking the down arrow button to the right of the field. Notes - A free form area to add notes about the transaction for later reference Other fields are... Reconcile - Used to check mark the transaction as clear through your bank. Normally done with the end of the month transaction statement Report: By Year/Month Cancel This script will show you the report in print preview mode. When you are finished viewing it, click the "Continue" button on the left side. This will bring up a dialog box asking you if you want to print it or not. script will show you the report in print preview mode. When you are finished viewing it, click the "Continue" button on the left side. This will bring up a dialog box asking you if you want to print it or not. )11BB1 )JZRR sJBBJBBZkckkRBBJJB9)!)!1Zc Cancel I don't work yet!B routine that helps you. v Entry Screenw New Recordx Find Recordy Print| Preferences PRINT: About/HelpB ABDN>> PRINT: PreferencesB PRINT: Help Cancel The Help information has been printed. Print Found Set Print Current Record THE SCREENS Checkbook 99 has 9 main screens which are About, Help, Preferences, Form View, List, Reconcile, RPT Month/Year w list, RPT Month/Year and RPT Month/Year Class. The About screen explains the goals of the database, new features, contact information, navigation buttons and the GO/DO interactive pick list. The Help screen is available from under the Scripts menu and contains information to help in using Checkbook 99 to it s fullest potential. The Preferences screen is used to define how you would like FileMaker to cleanup check balances. FileMaker cannot automatically cleanup the running balances if you enter in checks and deposits out of order. The Form View looks like a standard check register you are probably used to. A row of buttons flank the top of the screen for operation and navigation. The List View shows most of the key information in a one record on one line type of setting. The Reconcile View gives you an overall view of the subtractions to REPLACEMENT OF THE PARTICULAR LESAUX FILEMAKER TEMPLATE. 5. Limitation of Remedies and Damages. In no event will the Author, or any of the licensors, directors, officers, employees or affiliates of any of the foregoing be liable to you for any consequential, incidental, indirect or special damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information and the like), whether foreseeable or unforeseeable, arisin g out of the use of or inability to use the Solutions or accompanying written materials, regardless of the basis of the claim and even if the Author or a Author's representative has been advised of the possibility of such damage. Author s liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the money paid for this LeSaux FileMaker template that caused the damages. LightGrayTabB DarkGrayTabB Tab1NameB Tab2NameB Tab3NameB Tab4NameB Tab5NameB Tab6NameB Tab7NameB Record StatusB Total Records Total Records Services or Dwayne Wright. This License will terminate immediately without notice from the Author or judicial resolution if you fail to comply with any provision of this License. Upon such termination you must destroy this LeSaux FileMaker template, all accompanying written materials, and all copies thereof. You may also terminate this License at any time by destroying this LeSaux FileMaker template, all accompanying written materials and all copies thereof. 4. Limited Warranty and D isclaimer, Limitation of Remedies and Damages. EVERY LESAUX FILEMAKER TEMPLATE IS LICENSED AS IS. THE AUTHOR EXPRESSLY DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN THE EVENT THAT ANY WARRANTY IS IMPOSED BY LAW, AUTHOR S ENTIRE LIABILITY AND YOUR SOLE AND EXCLUSIVE REMEDY FOR ANY WARRANTY WILL BE, AT THE AUTHORS OPTION, REPLACEMENT OF THE SHIPPED MEDIA, REFUND OF THE PURCHASE PRICE, OR REPAIR/ y granted to you. You own the floppy disk, if you purchased the template in that manner, on which the template is recorded or fixed, but Author and its licensors retain ownership of the enclosed product. Only those users that have paid the complete registration fee for the associated database is allowed access to field creation, field modification, scripting or relationship setting access. The locked password with these templates can only be acquired from LeSaux Media Services. Any acqui red access to these areas from other sources than LeSaux Media Services is a breach of this software license and this product must be removed from your system immediately. 1. License. This License allows you to use this template with an authorized copy of the FileMaker Pro application software or FileMaker Pro Runtime User application if distributed in that manner. To the enclosed template means that templates are either loaded in the temporary memory (i.e., RAM) of a computer or installed on the permanent memory of a computer (i.e., hard disk, etc.). You may make an additional copy of these templates for backup purposes. Furthermore, if you have more than one authorized copy of the FileMaker Pro application, you may use the template on any machine in the immediate office - one copy for each authorized copy of FileMaker Pro . The Licensee agrees that: 1. the Licensee will not copy the template except as necessary to run the template on each computer in the imm ediate office 2. the Licensee will not copy the documentation except for inter-office use 3. the Licensee will not transfer to another party except as authorized by LeSaux Media Services in writing 4. the Licensee will not reverse engineer or disassemble the template to be marketed as a separate FileMaker template product 5. the Licensee wlll not remove or obsure any copyright or trademark notices on the software or documentation 6. Licensee will pay the registration fee if the product is used regularly over the first 30 day trial period 2. Restrictions. (a) WITHOUT LIMITATION, YOU MAY NOT USE, COPY, MODIFY OR DISTRIBUTE LESAUX FILEMAKER TEMPLATE PRODUCTS FOR USE IN ANY OTHER WAY THAN INTEROFFICE USE WITHOUT WRITTEN PERMISSION FROM DWAYNE WRIGHT OR LESAUX MEDIA SERVICES. EXCEPT AS SPECIFICALLY SET FORTH IN THIS LICENSE, YOU MAY NOT OTHERWISE USE, COPY, MODIFY, DISTRIBUTE, ADAPT, TRANSLATE, RENT, LEASE, LOAN, RESELL FOR PROFIT, DISTRIBUTE, OR CREATE DERIVATIVE WORKS BA SED UPON A LESAUX FILEMAKER TEMPLATE OR ANY PORTION OF A LESAUX FILEMAKER TEMPLATE WITHOUT WRITTEN PERMISSION FROM DWAYNE WRIGHT OR LESAUX MEDIA SERVICES. (b) Each LeSaux FileMaker template is protected by copyright law. As an express condition of this License, you must reproduce on each copy the Authors copyright notice and any other proprietary legends that were on the original copy supplied by the Author. 3. Termination. This License is effective until terminated by LeSaux Media 19BB91 BJRJJR RBJJBB9) 1ZZ919911 9119BJJB9) 9RJBJRZ ZRJBBJRk {cJBJRRZ B 1)!!)JcJ91 9B9199 BJJZks{{skZRJBB 9119BJJB9) 9RJBJRZ {cJBJRRZ B 1)!!)JcJ91 19B9199 BJJZks{{skZRJBB 9119BJJB9) 9RJBJRZ ZRJBBJRk {cJBJRRZ B 1)!!)JcJ91 19B9199 BJJZks{{skZ skZJ9 9JJBJRZ ZRJBBRk cJBJRZcs cZRJJ 9ccB99B B9199 19B9199119911 BJJRZk {kcRB 19BBJJRZRJJRRJJ )BJBBJZ ZRJBJZ kRBJZcs{skkcZR B919B9199119911 BJJRZk {kcRB 19BBJJRZRJJRRJJ )BJBBJZ ZRJBJZ{ kRBJZcs{skkcZR ]1Checkbook Version 99 1999 LeSaux Media Services sRRZk J1))!! )Z{{ZB9B 9 199199119B {skRB BJZcZJB )199B {cJJk {skZRZZJJB91)!! )ksZB99B99BB11 BJJRZZ BJZcZJ JRB911 !!)19B sZJJk {scRZZRJJ91 JskRB1 199119B91 9 BJJRRZZRRJ